{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Dashboard","Solar"],"not_rendered":{"charts":2,"images":3,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":39,"n_cols":2,"rows_kept":39,"cut":false,"hidden":false,"merged":[[35,1,35,3]]}
[]
[null,"Renewables First"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Purpose"]
[null,"-The LCOE Tariff Calculator is designed  to help energy sector stakeholders calculate accurate lifetime energy cost of power generation technologies. "]
[null,"-It makes complex financial analysis accessible to everyone from developers to policymakers."]
[]
[null,"Description"]
[null,"-This tool determines the total cost per unit of electricity for a utility scale solar power plant with a 25 year PPA. "]
[null,"-It factors in all major costs (capital, operations, maintenance), includes financial parameters (discount rates, capital structure), and provides detailed analysis with technology-specific considerations."]
[null,"-Uses industry-standard methods for reliable results."]
[]
[null,"Note"]
[null,"-This workbook requires both Macros and Iterative Calculations to function properly."]
[]
[null,"-To Enable Macros:\n1. Look for the yellow security warning at the top of Excel\n2. Click \"Enable Content\" or \"Enable Macros\""]
[]
[null,"-If Macros are Disabled at Security Level:\n1. Go to File > Options > Trust Center\n2. Click \"Trust Center Settings\"\n3. Select \"Macro Settings\"\n4. Choose \"Enable all macros\" "]
[]
[null,"-To Manually Enable Iterations (if needed):\n1. Go to File > Options\n2. Click \"Formulas\"\n3. Check \"Enable iterative calculation\"\n4. Set Maximum Iterations to 100\n5. Set Maximum Change to 0.001"]
[]
[null,"Disclaimer"]
[null,"-Results depend on input accuracy"]
[null,"-Uses standardized assumptions that may differ from local conditions"]
[null,"-Future projections carry inherent uncertainties"]
[null,"-Not meant as financial advice"]
[null,"-No liability accepted for decisions based on results"]
[null,"-Uses simplified models suitable for general planning"]
[]
[]
[]
[null,"2025 Renewables First. All Rights Reserved.\nDeveloped by Ahtasam Ahmad\n\nThis work is proprietary and confidential. No part of this document may be reproduced, distributed, or transmitted in any form or by any means, without the prior written permission of Renewables First. Unauthorized use, reproduction, or distribution may result in legal action.\n\nFor permissions and inquiries, please contact:\nRenewables First\n+92 51 88773676\ninfo@renewablesfirst.org"]

{"sheet":"Dashboard","index":1,"n_rows":51,"n_cols":34,"rows_kept":51,"cut":false,"hidden":false,"merged":[[1,2,1,3],[1,0,1,1],[2,0,2,1],[3,0,3,1],[8,0,8,3]]}
[]
[null,null,"Solar - 25 year PPA "]
["Levelized Tariff",null,"US cents",{"$f":"IF(OR(D23>48,D41>25,D44>25),\"False Entry\",Solar!D6)","v":3.6224140907000955},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Levelized Tariff Solar"]
[null,null,"Rs./kWh",{"$f":"D3*D47/100","v":10.070311172146265}]
[]
[]
["This workbook requires Macros to run. Enable Macros by clicking \"Enable Content\" in the security warning bar. The macro will automatically enable iteration settings. If calculation errors persist e.g. \"Microsoft has blocked macros from running,\" manually enable iteration in File > Options > Formulas > Enable iterative calculation. For detailed steps, refer to the instructions sheet. "]
[]
["Please populate the following  fields with project particulars to calculate the LCOE"]
[]
["Generation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,14.2]
["Capacity (MW) (Name Plate Capacity)",null,null,120,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016,13.4]
["Capacity Factor (Based On Technical Feasibility)",null,"%",0.24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2017,13.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018,11.6]
["Project Cost in USD - Million (M)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,5.5]
["Engineering & Procurement Cost (E.g. PV Modules, Buildings, Balance of Plant, Cabling, Trackers, Inverters etc.)",null,"USD'M/MW",0.42,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,5.5]
["Degradation",null,"% of EPC",0.03,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2022,3.7]
["Project Development Cost (E.g. Feasibility Study, Advisors & Consultant Fee etc.)",null,"% of EPC",0.02,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,3.9]
["Land",null,"USD'M",2.75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Solar Tariff - New",{"$f":"D3","v":3.6224140907000955}]
["Insurance During the Project Construction Period",null,"% of EPC",4.0000000000000001E-3]
["Financing Fees",null,"% of Debt",0.02]
["Construction Period",null,"Months",10,"Not more than 48 months"]
[]
["Capital Structure",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["Debt as a % of Total Project Capital Expenditure",null,null,0.75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
["Equity",null,null,{"$f":"1-D27","v":0.25},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[]
["% of Debt Sourced From Foreign Lenders",null,null,0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
["% of Local Debt",null,null,{"$f":"1-D30","v":0.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
["Operational",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
["Fixed Operations & Maintenance",null,"USD/MW",9000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
["Insurance During Project's Tenor",null,"% of EPC",4.0000000000000001E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
["Financing and other assumptions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
["Local Financing Rate",null,null,0.15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
["Tenor",null,"Years",15,"Not more than 25 years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
["Foreign Financing Rate",null,null,0.09,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
["Tenor",null,"Years",15,"Not more than 25 years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
["Return on Equity",null,null,0.14000000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
["Exchange Rate",null,"USD/PKR",278,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25]

{"sheet":"Solar","index":2,"n_rows":173,"n_cols":38,"rows_kept":173,"cut":false,"hidden":true,"merged":[[68,20,68,32]]}
[null,null,"Solar "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Solar"]
["Capacity (MW)",null,null,{"$f":"Dashboard!D12","v":120}]
["Capacity Factor",null,null,{"$f":"Dashboard!D13","v":0.24},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IDC",null,null,null,null,null,null,null,null,null,null,null,"ROEDC"]
["Generation (MWh)",null,null,{"$f":"D4*(365*24)*D3","v":252288}]
["Levelized Tariff","US cents",null,{"$f":"L79","v":3.6224140907000955},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Local","USD'm",{"$f":"D28","v":22.200635761589403},null,null,null,"Foreign","USD'm",{"$f":"D27","v":22.200635761589403},null,null,null,null,"USD'm",{"$f":"D29","v":14.800423841059603}]
[null,"Rs./kWh"]
[]
["Project Cost (in USD'm)",null,null,null,null,null,null,null,null,null,"Financing and other assumptions",null,null,null,null,null,null,null,null,null,null,"Months","Opening Debt","Drawdown","IDC","Closing",null,"Months","Opening Debt","Drawdown","IDC","Closing",null,"Months","Opening Debt","Drawdown","ROE","Closing"]
[null,null,"Per MW","Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0,{"$f":"IF(V10>$D$22,0,$X$6/$D$22)","v":2.2200635761589402},{"$f":"SUM(W10:X10)*($O$13/12)","v":2.7750794701986752E-2},{"$f":"W10+X10","v":2.2200635761589402},null,1,0,{"$f":"IF(AB10>$D$22,0,$AD$6/$D$22)","v":2.2200635761589402},{"$f":"SUM(AC10:AD10)*($O$20/12)","v":1.6650476821192053E-2},{"$f":"AC10+AD10","v":2.2200635761589402},null,1,0,{"$f":"IF(AH10>$D$22,0,$AJ$6/$D$22)","v":1.4800423841059602},{"$f":"SUM(AI10:AJ10)*($O$24/12)","v":1.726716114790287E-2},{"$f":"AI10+AJ10","v":1.4800423841059602}]
["EPC Cost",null,{"$f":"Dashboard!D17","v":0.42},{"$f":"C11*D3","v":50.4},null,null,null,null,null,null,"KIBOR",null,null,"base",0.12,null,null,null,null,null,null,{"$f":"V10+1","v":2},{"$f":"IF(V11>$D$22,0,Z10)","v":2.2200635761589402},{"$f":"IF(V11>$D$22,0,$X$6/$D$22)","v":2.2200635761589402},{"$f":"SUM(W11:X11)*($O$13/12)","v":5.5501589403973504E-2},{"$f":"W11+X11","v":4.4401271523178805},null,{"$f":"AB10+1","v":2},{"$f":"IF(AB11>$D$22,0,AF10)","v":2.2200635761589402},{"$f":"IF(AB11>$D$22,0,$AD$6/$D$22)","v":2.2200635761589402},{"$f":"SUM(AC11:AD11)*($O$20/12)","v":3.3300953642384105E-2},{"$f":"AC11+AD11","v":4.4401271523178805},null,{"$f":"AH10+1","v":2},{"$f":"IF(AH11>$D$22,0,AL10)","v":1.4800423841059602},{"$f":"IF(AH11>$D$22,0,$AJ$6/$D$22)","v":1.4800423841059602},{"$f":"SUM(AI11:AJ11)*($O$24/12)","v":3.453432229580574E-2},{"$f":"AI11+AJ11","v":2.9600847682119205}]
["Degradation",{"$f":"Dashboard!D18","v":0.03},null,{"$f":"B12*D11","v":1.512},null,null,null,null,null,null,"Spread",null,null,null,2.5000000000000001E-2,null,null,null,null,null,null,3,{"$f":"IF(V12>$D$22,0,Z11)","v":4.4401271523178805},{"$f":"IF(V12>$D$22,0,$X$6/$D$22)","v":2.2200635761589402},{"$f":"SUM(W12:X12)*($O$13/12)","v":8.3252384105960253E-2},{"$f":"W12+X12","v":6.6601907284768203},null,3,{"$f":"IF(AB12>$D$22,0,AF11)","v":4.4401271523178805},{"$f":"IF(AB12>$D$22,0,$AD$6/$D$22)","v":2.2200635761589402},4.9951430463576148E-2,6.6601907284768203,null,3,{"$f":"IF(AH12>$D$22,0,AL11)","v":2.9600847682119205},{"$f":"IF(AH12>$D$22,0,$AJ$6/$D$22)","v":1.4800423841059602},{"$f":"SUM(AI12:AJ12)*($O$24/12)","v":5.1801483443708607E-2},{"$f":"AI12+AJ12","v":4.4401271523178805}]
["PDC",{"$f":"Dashboard!D19","v":0.02},null,{"$f":"B13*D11","v":1.008},null,null,null,null,null,null,"Local Financing Rate",null,null,null,{"$f":"Dashboard!D40","v":0.15},null,null,null,null,null,null,4,6.6601907284768203,2.2200635761589402,0.11100317880794701,8.8802543046357609,null,4,6.6601907284768203,2.2200635761589402,6.6601907284768211E-2,8.8802543046357609,null,4,4.4401271523178805,1.4800423841059602,6.9068644591611481E-2,5.9201695364238409]
["Land",null,null,{"$f":"Dashboard!D20","v":2.75},null,null,null,null,null,null,"Tenor",null,null,null,{"$f":"Dashboard!D41","v":15},null,null,null,null,null,null,5,8.8802543046357609,2.2200635761589402,0.13875397350993376,11.100317880794702,null,5,8.8802543046357609,2.2200635761589402,8.3252384105960253E-2,11.100317880794702,null,5,5.9201695364238409,1.4800423841059602,8.6335805739514354E-2,7.4002119205298014]
["Insurance during construction",{"$f":"Dashboard!D21","v":4.0000000000000001E-3},null,{"$f":"B15*D11","v":0.2016},null,null,null,null,null,null,"Qtr. Installment",null,null,4,{"$f":"O14*N15","v":60},null,null,null,null,null,null,6,11.100317880794702,2.2200635761589402,0.16650476821192051,13.320381456953642,null,6,11.100317880794702,2.2200635761589402,9.9902860927152309E-2,13.320381456953642,null,6,7.4002119205298014,1.4800423841059602,0.10360296688741721,8.8802543046357609]
["CAPEX",null,null,{"$f":"SUM(D11:D15)","v":55.871600000000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,13.320381456953642,2.2200635761589402,0.19425556291390728,15.540445033112583,null,7,13.320381456953642,2.2200635761589402,0.11655333774834437,15.540445033112583,null,7,8.8802543046357609,1.4800423841059602,0.12087012803532009,10.360296688741721]
["Financing fees",{"$f":"Dashboard!D22","v":0.02},null,{"$f":"D19*B17*B26","v":0.88802543046357618},null,null,null,null,null,null,"SoFR ",null,null,"base",4.6800000000000001E-2,null,null,null,null,null,null,8,15.540445033112583,2.2200635761589402,0.22200635761589402,17.760508609271522,null,8,15.540445033112583,2.2200635761589402,0.13320381456953642,17.760508609271522,null,8,10.360296688741721,1.4800423841059602,0.13813728918322296,11.840339072847682]
["IDC",null,null,{"$f":"AE64+Y64","v":2.4420699337748339},null,null,null,null,null,null,"Credit Adjustment Spread",null,null,null,0,null,null,null,null,null,null,9,17.760508609271522,2.2200635761589402,0.24975715231788073,19.980572185430461,null,9,17.760508609271522,2.2200635761589402,0.14985429139072845,19.980572185430461,null,9,11.840339072847682,1.4800423841059602,0.15540445033112582,13.320381456953642]
["Total Project Cost",null,{"$f":"D19/$D$3","v":0.49334746136865343},{"$f":"SUM(D17:D18)+D16","v":59.201695364238411},null,null,null,null,null,null,"Spread ",null,null,null,4.2500000000000003E-2,null,null,null,null,null,null,10,19.980572185430461,2.2200635761589402,0.27750794701986747,22.2006357615894,null,10,19.980572185430461,2.2200635761589402,0.16650476821192048,22.2006357615894,null,10,13.320381456953642,1.4800423841059602,0.17267161147902871,14.800423841059603]
[null,null,null,null,null,null,null,null,null,null,"Foreign Financing Rate",null,null,null,{"$f":"Dashboard!D43","v":0.09},null,null,null,null,null,null,11,0,0,0,0,null,11,{"$f":"IF(AB20>$D$22,0,AF19)","v":0},{"$f":"IF(AB20>$D$22,0,$AD$6/$D$22)","v":0},{"$f":"SUM(AC20:AD20)*($O$20/12)","v":0},{"$f":"AC20+AD20","v":0},null,11,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,"Tenor",null,null,null,{"$f":"Dashboard!D44","v":15},null,null,null,null,null,null,12,0,0,0,0,null,12,0,0,0,0,null,12,0,0,0,0]
["Construction Period","months",null,{"$f":"Dashboard!D23","v":10},null,null,null,null,null,null,"Qtr. Installment",null,null,4,{"$f":"O21*N22","v":60},null,null,null,null,null,null,13,0,0,0,0,null,13,0,0,0,0,null,13,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,0,0,0,0,null,14,0,0,0,0,null,14,0,0,0,0]
["Capital Structure",null,null,null,null,null,null,null,null,null,"ROE ",null,null,null,{"$f":"Dashboard!D46","v":0.14000000000000001},null,null,null,null,null,null,15,0,0,0,0,null,15,0,0,0,0,null,15,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,"Exchange. Rate",null,null,null,{"$f":"Dashboard!D47","v":278},null,null,null,null,null,null,16,0,0,0,0,null,16,0,0,0,0,null,16,0,0,0,0]
["Debt",{"$f":"Dashboard!D27","v":0.75},null,{"$f":"$B26*D19","v":44.401271523178806},null,null,null,null,null,null,"Discount Rate",null,null,null,{"$f":"(O13*B28*B26)+(O20*B27*B26)+(O24*B29)","v":0.125},null,null,null,null,null,null,17,0,0,0,0,null,17,0,0,0,0,null,17,0,0,0,0]
["Foreign",{"$f":"Dashboard!D30","v":0.5},null,{"$f":"$B27*D$26","v":22.200635761589403},null,null,null,null,null,null,"Project Life",null,null,null,25,null,null,null,null,null,null,18,0,0,0,0,null,18,0,0,0,0,null,18,0,0,0,0]
["Local",{"$f":"1-B27","v":0.5},null,{"$f":"$B28*D$26","v":22.200635761589403},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,0,0,0,0,null,19,0,0,0,0,null,19,0,0,0,0]
["Equity",{"$f":"1-B26","v":0.25},null,{"$f":"$B29*D19","v":14.800423841059603},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,0,0,0,0,null,20,0,0,0,0,null,20,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,0,0,0,0,null,21,0,0,0,0,null,21,0,0,0,0]
["Tariff",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,0,0,0,0,null,22,0,0,0,0,null,22,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,0,0,0,0,null,23,0,0,0,0,null,23,0,0,0,0]
[null,null,"Solar ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,0,0,0,0,null,24,0,0,0,0,null,24,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,0,0,0,0,null,25,0,0,0,0,null,25,0,0,0,0]
[null,null,"USD'000","Rs./kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,0,0,0,0,null,26,0,0,0,0,null,26,0,0,0,0]
["Fixed O&M - Local",{"$f":"Dashboard!D35","v":9000},{"$f":"B36*D3/1000","v":1080},{"$f":"(C36*$O$25)/(D5)","v":1.1900684931506849},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,0,0,0,0,null,27,0,0,0,0,null,27,0,0,0,0]
["Fixed O&M - Foreign",null,{"$f":"$E$23*B37/1000","v":0},{"$f":"(C37*$O$25)/(D5)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,0,0,0,0,null,28,0,0,0,0,null,28,0,0,0,0]
["Insurance",{"$f":"Dashboard!D36","v":4.0000000000000001E-3},{"$f":"D11*$B$38*1000","v":201.6},{"$f":"(C38*$O$25)/($D$5)","v":0.22214611872146117},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,0,0,0,0,null,29,0,0,0,0,null,29,0,0,0,0]
["ROE",null,{"$f":"$O$24*D29*1000","v":2072.0593377483447},{"$f":"(C39*$O$25)/($D$5)","v":2.2832338275860917},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,0,0,0,null,30,0,0,0,0,null,30,0,0,0,0]
["ROEDC",null,{"$f":"AK64*1000","v":949.69386313465782},{"$f":"-PMT(O24,O27,(C40*O25/D5),)","v":0.15226148981185869},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,0,0,0,0,null,31,0,0,0,0,null,31,0,0,0,0]
["Principal - Local",null,{"$f":"(SUM(W74:W77)-SUM(X74:X77))*1000","v":434.55669547675234},{"$f":"(C41*$O$25)/($D$5)","v":0.47884465905051826},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,0,0,0,0,null,32,0,0,0,0,null,32,0,0,0,0]
["Interest Service - Local",null,{"$f":"(SUM(X74:X77))*1000","v":3306.4011572427844},{"$f":"(C42*$O$25)/($D$5)","v":3.6433739286588902},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,0,0,0,0,null,33,0,0,0,0,null,33,0,0,0,0]
["Principal - Foreign",null,{"$f":"(SUM(AE74:AE77)-SUM(AF74:AF77))*1000","v":738.00335122705633},{"$f":"(C43*$O$25)/($D$5)","v":0.81321716308790615},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,0,0,0,0,null,34,0,0,0,0,null,34,0,0,0,0]
["Interest Service - Foreign",null,{"$f":"(SUM(AF74:AF77))*1000","v":1973.6113819653233},{"$f":"(C44*$O$25)/($D$5)","v":2.1747525216671417},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,0,0,0,0,null,35,0,0,0,0,null,35,0,0,0,0]
["Total Tariff - debt service period",null,null,{"$f":"SUM(D36:D44)","v":10.957898201734553},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,0,0,0,0,null,36,0,0,0,0,null,36,0,0,0,0]
["Total Tariff - non-debt service period",null,null,{"$f":"D45-D43-D44-D42-D41","v":3.8477099292700969},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,0,0,0,0,null,37,0,0,0,0,null,37,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,0,0,0,0,null,38,0,0,0,0,null,38,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,0,0,0,0,null,39,0,0,0,0,null,39,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,0,0,0,0,null,40,0,0,0,0,null,40,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,0,0,0,0,null,41,0,0,0,0,null,41,0,0,0,0]
["Tariff Table (Solar)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,0,0,0,0,null,42,0,0,0,0,null,42,0,0,0,0]
[null,null,null,null,null,null,"Local",null,"Foreign",null,null,null,null,null,null,null,null,null,null,null,null,43,0,0,0,0,null,43,0,0,0,0,null,43,0,0,0,0]
["Year","O&M\nLocal","O&M Foreign","Insurance","ROE","ROEDC","Principal","Interest ","Principal","Interest ","Total","cents/kWh",null,null,null,null,null,null,null,null,null,44,0,0,0,0,null,44,0,0,0,0,null,44,0,0,0,0]
[1,{"$f":"D36","v":1.1900684931506849},{"$f":"D37","v":0},{"$f":"D38","v":0.22214611872146117},{"$f":"D39","v":2.2832338275860917},{"$f":"D40","v":0.15226148981185869},{"$f":"D41","v":0.47884465905051826},{"$f":"D42","v":3.6433739286588902},{"$f":"D43","v":0.81321716308790615},{"$f":"D44","v":2.1747525216671417},{"$f":"SUM(B54:J54)","v":10.957898201734553},{"$f":"K54/$O$25*100","v":3.9416900006239395},null,null,null,null,null,null,null,null,null,45,0,0,0,0,null,45,0,0,0,0,null,45,0,0,0,0]
[{"$f":"A54+1","v":2},{"$f":"B54","v":1.1900684931506849},{"$f":"C54","v":0},0.22214611872146117,2.2832338275860917,0.15226148981185869,0.47884465905051826,3.6433739286588902,0.81321716308790615,2.1747525216671417,{"$f":"SUM(B55:J55)","v":10.957898201734553},{"$f":"K55/$O$25*100","v":3.9416900006239395},null,null,null,null,null,null,null,null,null,46,0,0,0,0,null,46,0,0,0,0,null,46,0,0,0,0]
[{"$f":"A55+1","v":3},{"$f":"B55","v":1.1900684931506849},{"$f":"C55","v":0},{"$f":"D55","v":0.22214611872146117},{"$f":"E55","v":2.2832338275860917},{"$f":"F55","v":0.15226148981185869},{"$f":"G55","v":0.47884465905051826},{"$f":"H55","v":3.6433739286588902},{"$f":"I55","v":0.81321716308790615},{"$f":"J55","v":2.1747525216671417},10.957898201734553,3.9416900006239395,null,null,null,null,null,null,null,null,null,47,0,0,0,0,null,47,0,0,0,0,null,47,0,0,0,0]
[4,1.1900684931506849,0,0.22214611872146117,2.2832338275860917,0.15226148981185869,0.47884465905051826,3.6433739286588902,0.81321716308790615,2.1747525216671417,10.957898201734553,3.9416900006239395,null,null,null,null,null,null,null,null,null,48,0,0,0,0,null,48,0,0,0,0,null,48,0,0,0,0]
[5,1.1900684931506849,0,0.22214611872146117,2.2832338275860917,0.15226148981185869,0.47884465905051826,3.6433739286588902,0.81321716308790615,2.1747525216671417,10.957898201734553,3.9416900006239395,null,null,null,null,null,null,null,null,null,49,0,0,0,0,null,49,0,0,0,0,null,49,0,0,0,0]
[6,1.1900684931506849,0,0.22214611872146117,2.2832338275860917,0.15226148981185869,0.47884465905051826,3.6433739286588902,0.81321716308790615,2.1747525216671417,10.957898201734553,3.9416900006239395,null,null,null,null,null,null,null,null,null,50,0,0,0,0,null,50,0,0,0,0,null,50,0,0,0,0]
[7,1.1900684931506849,0,0.22214611872146117,2.2832338275860917,0.15226148981185869,0.47884465905051826,3.6433739286588902,0.81321716308790615,2.1747525216671417,10.957898201734553,3.9416900006239395,null,null,null,null,null,null,null,null,null,51,0,0,0,0,null,51,0,0,0,0,null,51,0,0,0,0]
[8,1.1900684931506849,0,0.22214611872146117,2.2832338275860917,0.15226148981185869,0.47884465905051826,3.6433739286588902,0.81321716308790615,2.1747525216671417,10.957898201734553,3.9416900006239395,null,null,null,null,null,null,null,null,null,52,0,0,0,0,null,52,0,0,0,0,null,52,0,0,0,0]
[9,1.1900684931506849,0,0.22214611872146117,2.2832338275860917,0.15226148981185869,0.47884465905051826,3.6433739286588902,0.81321716308790615,2.1747525216671417,10.957898201734553,3.9416900006239395,null,null,null,null,null,null,null,null,null,53,0,0,0,0,null,53,0,0,0,0,null,53,0,0,0,0]
[10,1.1900684931506849,0,0.22214611872146117,2.2832338275860917,0.15226148981185869,0.47884465905051826,3.6433739286588902,0.81321716308790615,2.1747525216671417,10.957898201734553,3.9416900006239395,null,null,null,null,null,null,null,null,null,54,0,0,0,0,null,54,0,0,0,0,null,54,0,0,0,0]
[11,1.1900684931506849,0,0.22214611872146117,2.2832338275860917,0.15226148981185869,0.47884465905051826,3.6433739286588902,0.81321716308790615,2.1747525216671417,10.957898201734553,3.9416900006239395,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(X10:X63)","v":22.2006357615894},{"$f":"SUM(Y10:Y63)","v":1.5262937086092712},null,null,null,null,{"$f":"SUM(AD10:AD63)","v":22.2006357615894},{"$f":"SUM(AE10:AE63)","v":0.91577622516556278},null,null,null,null,{"$f":"SUM(AJ10:AJ63)","v":14.800423841059603},{"$f":"SUM(AK10:AK63)","v":0.94969386313465787}]
[12,1.1900684931506849,0,0.22214611872146117,2.2832338275860917,0.15226148981185869,0.47884465905051826,3.6433739286588902,0.81321716308790615,2.1747525216671417,10.957898201734553,3.9416900006239395]
[13,1.1900684931506849,0,0.22214611872146117,2.2832338275860917,0.15226148981185869,0.47884465905051826,3.6433739286588902,0.81321716308790615,2.1747525216671417,10.957898201734553,3.9416900006239395]
[14,1.1900684931506849,0,0.22214611872146117,2.2832338275860917,0.15226148981185869,0.47884465905051826,3.6433739286588902,0.81321716308790615,2.1747525216671417,10.957898201734553,3.9416900006239395]
[15,1.1900684931506849,0,0.22214611872146117,2.2832338275860917,0.15226148981185869,0.47884465905051826,3.6433739286588902,0.81321716308790615,2.1747525216671417,10.957898201734553,3.9416900006239395]
[16,{"$f":"B68","v":1.1900684931506849},{"$f":"C68","v":0},{"$f":"D68","v":0.22214611872146117},{"$f":"E68","v":2.2832338275860917},{"$f":"F68","v":0.15226148981185869},0,0,0,0,3.8477099292700965,1.3840683198813297,null,null,null,null,null,null,null,null,"Loan Amortization"]
[17,1.1900684931506849,0,0.22214611872146117,2.2832338275860917,0.15226148981185869,0,0,0,0,3.8477099292700965,1.3840683198813297]
[18,1.1900684931506849,0,0.22214611872146117,2.2832338275860917,0.15226148981185869,0,0,0,0,3.8477099292700965,1.3840683198813297,null,null,null,null,null,null,null,null,null,null,{"$f":"X64","v":22.2006357615894},null,null,null,null,null,null,null,{"$f":"AD64","v":22.2006357615894}]
[19,1.1900684931506849,0,0.22214611872146117,2.2832338275860917,0.15226148981185869,0,0,0,0,3.8477099292700965,1.3840683198813297]
[20,1.1900684931506849,0,0.22214611872146117,2.2832338275860917,0.15226148981185869,0,0,0,0,3.8477099292700965,1.3840683198813297,null,null,null,null,null,null,null,null,"Year","Opening","Repayment","Interest","Closing",null,null,null,"Year","Opening","Repayment","Interest","Closing"]
[21,1.1900684931506849,0,0.22214611872146117,2.2832338275860917,0.15226148981185869,0,0,0,0,3.8477099292700965,1.3840683198813297,null,null,null,null,null,null,null,null,1,{"$f":"IF(U74>$O$14,0,W71)","v":22.2006357615894},{"$f":"IF(U74>$O$14,0,-PMT(O13/N15,O15,W71,))","v":0.93523946317988416},{"$f":"(V74*($O$13/$N$15))","v":0.83252384105960242},{"$f":"V74-(W74-X74)","v":22.097920139469117},null,null,null,1,{"$f":"IF(AC74>O21,0,AE71)","v":22.2006357615894},{"$f":"IF(AC74>O21,0,-PMT(O20/N22,O22,AE71,))","v":0.67790368329809492},{"$f":"(AD74*($O$20/$N$22))","v":0.49951430463576146},{"$f":"AD74-(AE74-AF74)","v":22.022246382927065}]
[22,1.1900684931506849,0,0.22214611872146117,2.2832338275860917,0.15226148981185869,0,0,0,0,3.8477099292700965,1.3840683198813297,null,null,null,null,null,null,null,null,1,{"$f":"IF(U75>$O$14,0,Y74)","v":22.097920139469117},{"$f":"IF(U75>$O$14,0,W74)","v":0.93523946317988416},{"$f":"(V75*($O$13/$N$15))","v":0.82867200523009188},{"$f":"V75-(W75-X75)","v":21.991352681519324},null,null,null,1,{"$f":"IF(AC75>$O$21,0,AG74)","v":22.022246382927065},{"$f":"IF(AC75>$O$21,0,AE74)","v":0.67790368329809492},{"$f":"(AD75*($O$20/$N$22))","v":0.49550054361585893},{"$f":"AD75-(AE75-AF75)","v":21.839843243244829}]
[23,1.1900684931506849,0,0.22214611872146117,2.2832338275860917,0.15226148981185869,0,0,0,0,3.8477099292700965,1.3840683198813297,null,null,null,null,null,null,null,null,1,{"$f":"IF(U76>$O$14,0,Y75)","v":21.991352681519324},{"$f":"IF(U76>$O$14,0,W75)","v":0.93523946317988416},0.82467572555697466,{"$f":"V76-(W76-X76)","v":21.880788943896412},null,null,null,1,{"$f":"IF(AC76>$O$21,0,AG75)","v":21.839843243244829},{"$f":"IF(AC76>$O$21,0,AE75)","v":0.67790368329809492},{"$f":"(AD76*($O$20/$N$22))","v":0.49139647297300865},{"$f":"AD76-(AE76-AF76)","v":21.653336032919743}]
[24,1.1900684931506849,0,0.22214611872146117,2.2832338275860917,0.15226148981185869,0,0,0,0,3.8477099292700965,1.3840683198813297,null,null,null,null,null,null,null,null,1,21.880788943896412,0.93523946317988416,0.82052958539611542,21.766079066112646,null,null,null,1,21.653336032919743,{"$f":"IF(AC77>$O$21,0,AE76)","v":0.67790368329809492},0.48720006074069422,21.462632410362342]
[25,1.1900684931506849,0,0.22214611872146117,2.2832338275860917,0.15226148981185869,0,0,0,0,3.8477099292700965,1.3840683198813297,null,null,null,null,null,null,null,null,2,21.766079066112646,0.93523946317988416,0.81622796497922423,21.647067567911986,null,null,null,2,21.462632410362342,{"$f":"IF(AC78>$O$21,0,AE77)","v":0.67790368329809492},0.48290922923315271,21.267637956297399]
["Levelized ",{"$f":"PMT($O$26,$A$78,-NPV($O$26,B54:B78) )","v":1.1900684931506846},0,0.22214611872146114,2.2832338275860917,0.15226148981185872,0.41906898331956466,3.1885601713999869,0.7117007223783518,1.9032713657782665,{"$f":"PMT($O$26,$A$78,-NPV($O$26,K54:K78) )","v":10.070311172146265},3.6224140907000955,null,null,null,null,null,null,null,null,2,21.647067567911986,0.93523946317988416,0.8117650337966994,21.523593138528803,null,null,null,2,21.267637956297399,0.67790368329809492,0.47852185401669145,21.068256127015996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,21.523593138528803,0.93523946317988416,0.8071347426948301,21.395488418043747,null,null,null,2,21.068256127015996,0.67790368329809492,0.47403576285785987,20.864388206575761]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,21.395488418043747,0.93523946317988416,0.80233081567664055,21.262579770540505,null,null,null,2,20.864388206575761,0.67790368329809492,0.46944873464795461,20.655933257925621]
[null,null,"O&M","Insurance","ROE","ROEDC","Principal (Local)","Interest (Local) ","Principal (Foreign)","Interest (Foreign)","Total",null,null,null,null,null,null,null,null,null,3,21.262579770540505,0.93523946317988416,0.79734674139526895,21.124687048755888,null,null,null,3,20.655933257925621,0.67790368329809492,0.46475849830332644,20.442788072930853]
[null,null,{"$f":"B79","v":1.1900684931506846},{"$f":"D79","v":0.22214611872146114},{"$f":"E79","v":2.2832338275860917},{"$f":"F79","v":0.15226148981185872},0.41906898331956466,3.1885601713999869,0.7117007223783518,1.9032713657782665,10.070311172146265,null,null,null,null,null,null,null,null,null,3,21.124687048755888,0.93523946317988416,0.7921757643283458,20.98162334990435,null,null,null,3,20.442788072930853,0.67790368329809492,0.45996273164094414,20.224847121273701]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,20.98162334990435,0.93523946317988416,0.78681087562141305,20.83319476234588,null,null,null,3,20.224847121273701,0.67790368329809492,0.45505906022865827,20.002002498204263]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,20.83319476234588,0.93523946317988416,0.78124480358797044,20.679200102753967,null,null,null,3,20.002002498204263,0.67790368329809492,0.4500450562095959,19.774143871115765]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,20.679200102753967,0.93523946317988416,0.77547000385327369,20.519430643427356,null,null,null,4,19.774143871115765,0.67790368329809492,0.4449182371001047,19.541158424917775]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,20.519430643427356,0.93523946317988416,0.76947864912852582,20.353669829375999,null,null,null,4,19.541158424917775,0.67790368329809492,0.43967606456064995,19.302930806180331]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,20.353669829375999,0.93523946317988416,0.76326261860159994,20.181692984797714,null,null,null,4,19.302930806180331,0.67790368329809492,0.43431594313905741,19.059343066021295]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,20.181692984797714,0.93523946317988416,0.75681348692991424,20.003267008547745,null,null,null,4,19.059343066021295,0.67790368329809492,0.42883521898547911,18.810274601708681]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,20.003267008547745,0.93523946317988416,0.75012251282054043,19.818150058188401,null,null,null,5,18.810274601708681,0.67790368329809492,0.42323117853844533,18.555602096949031]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,19.818150058188401,0.93523946317988416,0.74318062718206501,19.626091222190581,null,null,null,5,18.555602096949031,0.67790368329809492,0.41750104718135317,18.29519946083229]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,19.626091222190581,0.93523946317988416,0.73597842083214682,19.426830179842845,null,null,null,5,18.29519946083229,0.67790368329809492,0.41164198786872652,18.028937765402922]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,19.426830179842845,0.93523946317988416,0.72850613174410672,19.220096848407067,null,null,null,5,18.028937765402922,0.67790368329809492,0.40565109972156571,17.756685181826395]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,19.220096848407067,0.93523946317988416,0.72075363181526497,19.005611017042447,null,null,null,6,17.756685181826395,0.67790368329809492,0.39952541659109386,17.478306915119393]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,19.005611017042447,0.93523946317988416,0.71271041313909178,18.783081967001657,null,null,null,6,17.478306915119393,0.67790368329809492,0.39326190559018631,17.193665137411486]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,18.783081967001657,0.93523946317988416,0.70436557376256215,18.552208077584336,null,null,null,6,17.193665137411486,0.67790368329809492,0.38685746559175843,16.902618919705148]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,18.552208077584336,0.93523946317988416,0.69570780290941259,18.312676417313863,null,null,null,6,16.902618919705148,0.67790368329809492,0.38030892569336583,16.60502416210042]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,18.312676417313863,0.93523946317988416,0.68672536564926989,18.06416231978325,null,null,null,7,16.60502416210042,0.67790368329809492,0.37361304364725945,16.300733522449583]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,18.06416231978325,0.93523946317988416,0.67740608699187188,17.806328943595236,null,null,null,7,16.300733522449583,0.67790368329809492,0.36676650425511559,15.989596343406603]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,17.806328943595236,0.93523946317988416,0.66773733538482138,17.538826815800174,null,null,null,7,15.989596343406603,0.67790368329809492,0.35976591772664857,15.671458577835157]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,17.538826815800174,0.93523946317988416,0.65770600559250647,17.261293358212797,null,null,null,7,15.671458577835157,0.67790368329809492,0.35260781800129104,15.346162712538353]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,17.261293358212797,0.93523946317988416,0.6472985009329798,16.973352395965893,null,null,null,8,15.346162712538353,0.67790368329809492,0.34528866103211292,15.013547690272372]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,16.973352395965893,0.93523946317988416,0.63650071484872095,16.674613647634729,null,null,null,8,15.013547690272372,0.67790368329809492,0.33780482303112835,14.673448830005405]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,16.674613647634729,0.93523946317988416,0.62529801178630229,16.364672196241148,null,null,null,8,14.673448830005405,0.67790368329809492,0.33015259867512159,14.325697745382431]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,16.364672196241148,0.93523946317988416,0.61367520735904302,16.043107940420306,null,null,null,8,14.325697745382431,0.67790368329809492,0.32232819927110468,13.97012226135544]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,16.043107940420306,0.93523946317988416,0.60161654776576146,15.709485025006183,null,null,null,9,13.97012226135544,0.67790368329809492,0.31432775088049741,13.606546328937842]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,15.709485025006183,0.93523946317988416,0.58910568843773181,15.36335125026403,null,null,null,9,13.606546328937842,0.67790368329809492,0.30614729240110145,13.234789938040848]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,15.36335125026403,0.93523946317988416,0.57612567188490105,15.004237458969047,null,null,null,9,13.234789938040848,0.67790368329809492,0.29778277360591904,12.854669028348672]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,15.004237458969047,0.93523946317988416,0.56265890471133928,14.631656900500502,null,null,null,9,12.854669028348672,0.67790368329809492,0.28923005313784511,12.465995398188422]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,14.631656900500502,0.93523946317988416,0.54868713376876876,14.245104571089387,null,null,null,10,12.465995398188422,0.67790368329809492,0.28048489645923946,12.068576611349567]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,14.245104571089387,0.93523946317988416,0.53419142141585196,13.844056529325355,null,null,null,10,12.068576611349567,0.67790368329809492,0.27154297375536524,11.662215901806837]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,13.844056529325355,0.93523946317988416,0.51915211984970078,13.427969185995172,null,null,null,10,11.662215901806837,0.67790368329809492,0.26239985779065383,11.246712076299396]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,13.427969185995172,0.93523946317988416,0.50354884447481896,12.996278567290107,null,null,null,10,11.246712076299396,0.67790368329809492,0.25305102171673638,10.821859414718038]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,12.996278567290107,0.93523946317988416,0.48736044627337899,12.548399550383602,null,null,null,11,10.821859414718038,0.67790368329809492,0.24349183683115583,10.387447568251098]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,12.548399550383602,0.93523946317988416,0.47056498313938505,12.083725070343103,null,null,null,11,10.387447568251098,0.67790368329809492,0.23371757028564968,9.9432614552386518]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,12.083725070343103,0.93523946317988416,0.45313969013786637,11.601625297301085,null,null,null,11,9.9432614552386518,0.67790368329809492,0.22372338274286965,9.4890811546834257]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,11.601625297301085,0.93523946317988416,0.43506094864879069,11.101446782769992,null,null,null,11,9.4890811546834257,0.67790368329809492,0.21350432598037708,9.0246817973657087]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,11.101446782769992,0.93523946317988416,0.41630425435387469,10.582511573943982,null,null,null,12,9.0246817973657087,0.67790368329809492,0.20305534044072843,8.5498334545083416]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,10.582511573943982,0.93523946317988416,0.39684418402289934,10.044116294786997,null,null,null,12,8.5498334545083416,0.67790368329809492,0.19237125272643768,8.0643010239366841]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,10.044116294786997,0.93523946317988416,0.37665436105451239,9.4855311926616253,null,null,null,12,8.0643010239366841,0.67790368329809492,0.1814467730385754,7.5678441136771646]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,9.4855311926616253,0.93523946317988416,0.35570741972481096,8.9059991492065524,null,null,null,12,7.5678441136771646,0.67790368329809492,0.17027649255773619,7.0602169229368057]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,8.9059991492065524,0.93523946317988416,0.33397496809524568,8.3047346541219138,null,null,null,13,7.0602169229368057,0.67790368329809492,{"$f":"(AD122*($O$20/$N$22))","v":0.15885488076607812},{"$f":"AD122-(AE122-AF122)","v":6.5411681204047891}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,8.3047346541219138,0.93523946317988416,0.31142754952957175,7.6809227404716012,null,null,null,13,6.5411681204047891,0.67790368329809492,0.14717628270910774,6.0104407198158016]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,7.6809227404716012,0.93523946317988416,0.28803460276768506,7.0337178800594025,null,null,null,13,6.0104407198158016,0.67790368329809492,0.13523491619585554,5.4677719527135622]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,7.0337178800594025,0.93523946317988416,0.26376442050222759,6.3622428373817463,null,null,null,13,5.4677719527135622,0.67790368329809492,0.12302486893605515,4.9128931383515226]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,6.3622428373817463,0.93523946317988416,0.23858410640181549,5.6655874806036781,null,null,null,14,4.9128931383515226,0.67790368329809492,0.11054009561290926,4.3455295506663365]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,5.6655874806036781,0.93523946317988416,0.21245953052263791,4.9428075479464315,null,null,null,14,4.3455295506663365,0.67790368329809492,9.777441488999257E-2,3.7654002822582342]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,4.9428075479464315,0.93523946317988416,0.18535528304799118,4.1929233678145383,null,null,null,14,3.7654002822582342,0.67790368329809492,8.4721506350810272E-2,3.1722181053109493]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,4.1929233678145383,0.93523946317988416,0.15723462629304519,3.4149185309276993,null,null,null,14,3.1722181053109493,0.67790368329809492,7.1374907369496352E-2,2.5656893293823506]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,3.4149185309276993,0.93523946317988416,0.12805944490978871,2.6077385126576038,null,null,null,15,2.5656893293823506,0.67790368329809492,5.7728009911102884E-2,1.9455136559953585]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,2.6077385126576038,0.93523946317988416,9.7790194224660135E-2,1.7702892437023798,null,null,null,15,1.9455136559953585,0.67790368329809492,4.3774057259895569E-2,1.3113840299571593]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,1.7702892437023798,0.93523946317988416,6.6385846638839244E-2,0.90143562716133496,null,null,null,15,1.3113840299571593,0.67790368329809492,2.9506140674036084E-2,0.6629864873331005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,0.90143562716133496,0.93523946317988416,3.3803836018550061E-2,8.8817841970012523E-16,null,null,null,15,0.6629864873331005,0.67790368329809492,1.4917195964994761E-2,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,0,0,0,0,null,null,null,16,{"$f":"IF(AC134>$O$21,0,AG133)","v":0},{"$f":"IF(AC134>$O$21,0,AE133)","v":0},{"$f":"(AD134*($O$20/$N$22))","v":0},{"$f":"AD134-(AE134-AF134)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,0,0,0,0,null,null,null,16,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,0,0,0,0,null,null,null,16,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,0,0,0,0,null,null,null,16,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,0,0,0,0,null,null,null,17,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,0,0,{"$f":"(V139*($O$13/$N$15))","v":0},0,null,null,null,17,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,{"$f":"IF(U140>$O$14,0,Y139)","v":0},{"$f":"IF(U140>$O$14,0,W139)","v":0},0,{"$f":"V140-(W140-X140)","v":0},null,null,null,17,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,0,0,0,0,null,null,null,17,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,0,0,0,0,null,null,null,18,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,0,0,0,0,null,null,null,18,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,0,0,0,0,null,null,null,18,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,0,0,0,0,null,null,null,18,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,0,0,0,0,null,null,null,19,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,0,0,0,0,null,null,null,19,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,0,0,0,0,null,null,null,19,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,0,0,0,0,null,null,null,19,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,0,0,0,0,null,null,null,20,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,0,0,0,0,null,null,null,20,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,0,0,0,0,null,null,null,20,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,0,0,0,0,null,null,null,20,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,0,0,0,0,null,null,null,21,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,0,0,0,0,null,null,null,21,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,0,0,0,0,null,null,null,21,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,0,0,0,0,null,null,null,21,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,0,0,0,0,null,null,null,22,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,0,0,0,0,null,null,null,22,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,0,0,0,0,null,null,null,22,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,0,0,0,0,null,null,null,22,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,0,0,0,0,null,null,null,23,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,0,0,0,0,null,null,null,23,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,0,0,0,0,null,null,null,23,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,0,0,0,0,null,null,null,23,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,0,0,0,0,null,null,null,24,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,0,0,0,0,null,null,null,24,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,0,0,0,0,null,null,null,24,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,0,0,0,0,null,null,null,24,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,0,0,0,0,null,null,null,25,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,0,0,0,0,null,null,null,25,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,0,0,0,0,null,null,null,25,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,0,0,0,0,null,null,null,25,0,0,0,0]